﻿if exists (select * from dbo.sysobjects where name = 'sp_Positions_Update')	drop procedure [dbo].[sp_Positions_Update]Go CREATE PROCEDURE dbo.sp_Positions_Update	@psID		int,	@Code		nvarchar(50),	@Name		nvarchar(150),	@Level		nvarchar(100),	@Ord		intAS	UPDATE [Positions] SET [Code] = @Code, [Name] = @Name, [Level] = @Level, [Ord] = @Ord	 WHERE psID = @psIDGo 